﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Text;
using DAL;

namespace dal.emoney
{
    /// <summary>

    /// Author:		 喻旻
    /// Create date: 2011-05-25
    /// Description:读取STOCK_ABNORMAL中的数据
    /// </summary>
    public class STOCK_ABNORMAL
    {
        public DataTable GetData()
        {
            StringBuilder sb = new StringBuilder();
            sb.AppendLine("select f025v_12001 stock_id,f021v_12001 stock_name from(");
            sb.AppendLine("select distinct top 50  f025v_12001,f021v_12001,f035d_12001 from vm_dms_getnewsbycode");
            sb.AppendLine("where code ='3070505' and F004V_12001=4 and f035d_12001<GETDATE()");
            sb.AppendLine("ORDER BY f035d_12001 desc");
            sb.AppendLine(") as a");
            return SqlHelper.ExecuteGetTable(DBManager.NewDMSConnstr, CommandType.Text, sb.ToString(), null);
        }
    }
}